<?PHP

// Config de Moodle, chemin à modifier en fonction du chemin d'installation de ce module
include('../../config.php');
  
$SECURITE="OK";

$CONF_chemin="../";
include('../includes/config/config.php');
  	$sql="select TYP_DIPLOME as id, diplome as valeur, count(*) as nb FROM ".$CONF_bdd_prefixe."aua_etape
	JOIN ".$CONF_bdd_prefixe."aua_typ_dip ON(TYP_DIPLOME=id)
	JOIN ".$CONF_bdd_prefixe."aua_structure USING(C_STRUCTURE)
	WHERE C_STRUCTURE='".$_POST['ufr']."'
	GROUP BY diplome
	ORDER BY diplome ASC";

	$query=mysql_query($sql);

echo mysql_error();
?>
	<OPTION  value="Aucun"> b) Sélectionnez un Niveau</OPTION>    
<?PHP		    
	while ($ligne=mysql_fetch_object($query))
	{
		echo "	<OPTION value='".$ligne->id."'>".$ligne->valeur." (".$ligne->nb.")</OPTION>";
	}
?>

